package com.burry.services;

import java.util.List;
import java.util.Map;

import com.burry.db.SQLMachine;

public class HoldService {
	
	
	public List getAllHold(String goodId,String colorId){
		String sql = "select * from bu_color_size where good_id = '"+goodId+"' and color_id = '"+colorId+"'";
		SQLMachine sqlM = new SQLMachine("default");
		return sqlM.getResultSet(sql);
	}
	
	public Map updateHold(String goodId,String colorId,String upper,String size,String holder){
		String sql = "update bu_color_size set upper_num = "+upper+" ,qnum = "+holder+" where good_id = '"+goodId+"' and color_id = '"+colorId+"' and size = '"+size+"'";
		SQLMachine sqlM = new SQLMachine("default");
		return sqlM.updateResult(sql);
	}
}
